import mysql.connector

conn=mysql.connector.connect(user='root',password='123456',database='jiang');
cursor=conn.cursor();

# cursor.execute('select * from book');
# data=cursor.fetchone();
# print(data);
sql="INSERT INTO house(name,unit_price,total_price,pianqu) VALUES ('晶蓝半岛一期222 ',33292,450,'九眼桥')";
cursor.execute(sql);
conn.commit();
